--
-- TDN_DISTRICT2  (Table) 
--

--DROP TABLE TDN_DISTRICT2;

--DROP SEQUENCE S_TDN_DISTRICT2;

CREATE TABLE TDN_DISTRICT2
(
  ID              INTEGER                       NOT NULL,
  VDIST_CODE      VARCHAR2(15 BYTE),
  VDISTNAME       VARCHAR2(200 BYTE),
  VDISTNAME_EN    VARCHAR2(200 BYTE),
  VDISTSHORTNAME  VARCHAR2(20 BYTE),
  VPROVCODE       VARCHAR2(10 BYTE)             NOT NULL,
  VCITYCODE       VARCHAR2(15 BYTE),
  VAREACODE       VARCHAR2(8 BYTE),
  VZIP_CODE       VARCHAR2(10 BYTE),
  VDISPORDER      VARCHAR2(10 BYTE),
  VDISPLAY        VARCHAR2(1 BYTE),
  VCREATED        VARCHAR2(8 BYTE),
  DCRT_DATE       DATE,
  VUPDATED        VARCHAR2(8 BYTE),
  DUP_DATE        DATE,
  PRIMARY KEY (ID)
);

CREATE SEQUENCE S_TDN_DISTRICT2;

INSERT INTO TDN_DISTRICT2 (SELECT S_TDN_DISTRICT2.NEXTVAL,A.* FROM TDN_DISTRICT A);

COMMIT;

COMMENT ON TABLE TDN_DISTRICT2 IS '县级市/区表－记录省/直辖市、地级市与县级市/区的关系，及邮编、区号等信息';

COMMENT ON COLUMN TDN_DISTRICT2.ID IS '主键(SEQUENCE:S_TDN_DISTRICT2)';

COMMENT ON COLUMN TDN_DISTRICT2.VDIST_CODE IS '县级市/区编码';

COMMENT ON COLUMN TDN_DISTRICT2.VDISTNAME IS '县级市/区中文名称';

COMMENT ON COLUMN TDN_DISTRICT2.VDISTNAME_EN IS '县级市/区英文名称';

COMMENT ON COLUMN TDN_DISTRICT2.VDISTSHORTNAME IS '县级市/区简称';

COMMENT ON COLUMN TDN_DISTRICT2.VPROVCODE IS '所属省份代码';

COMMENT ON COLUMN TDN_DISTRICT2.VCITYCODE IS '所属地级市代码';

COMMENT ON COLUMN TDN_DISTRICT2.VAREACODE IS '区号';

COMMENT ON COLUMN TDN_DISTRICT2.VZIP_CODE IS '邮编';

COMMENT ON COLUMN TDN_DISTRICT2.VDISPORDER IS '显示序号';

COMMENT ON COLUMN TDN_DISTRICT2.VDISPLAY IS '是否可显示(0-不可显示，1-可以显示)';

COMMENT ON COLUMN TDN_DISTRICT2.VCREATED IS '创建人(登陆用户)';

COMMENT ON COLUMN TDN_DISTRICT2.DCRT_DATE IS '创建日期时间';

COMMENT ON COLUMN TDN_DISTRICT2.VUPDATED IS '更新人(登陆用户)';

COMMENT ON COLUMN TDN_DISTRICT2.DUP_DATE IS '更新日期时间';

